INSERT INTO Users
	SELECT
		CONCAT(LOWER(SUBSTRING(e.FirstName, 1, 1)), '.', LOWER(e.LastName), CAST(EmployeeID AS NVARCHAR(5))),
		CONCAT(LOWER(SUBSTRING(e.FirstName, 1, 1)), '_pass_', LOWER(e.LastName)),
		CONCAT(e.FirstName, ' ', e.LastName),
		NULL,
		NULL
			FROM Employees e